﻿Public Class TimKiemSoPhieu_DAO
    'Tìm  phiếu xuất
    Public Shared Function selectBySoPhieuXuat(_sophieu As TimKiemSoPhieu_DTO) As DataTable
        Dim sophieu As DataTable
        Dim strSQL As String = "select * from PhieuXuat where SoPhieu like '%" & _sophieu.sophieu & "%'"
        sophieu = SQLProvider.ExecQuery(strSQL)
        Return sophieu

    End Function

    'Tim phiếu nhập
    Public Shared Function selectBySoPhieuNhap(_sophieu As TimKiemSoPhieu_DTO) As DataTable
        Dim sophieu As DataTable
        Dim strSQL As String = "select * from PhieuNhap where SoPhieu like '%" & _sophieu.sophieu & "%'"
        sophieu = SQLProvider.ExecQuery(strSQL)
        Return sophieu

    End Function

End Class
